MySQL ODBC driver installation

Introduction

Open Database Connectivity (ODBC) is a widely accepted application programming interface (API) for database access. It is based on the Call-Level Interface (CLI) specifications from X/Open and ISO/IEC for database APIs and uses Structured Query Language (SQL) as its database access language.

In the Following chapter we will see how to install:

The MYSQL ODBC driver

You should install the ODBC driver MyODBC 2.5 that fits with your Microsoft operating system. You will find all last version drivers and the documentation on the Web: http://dev.mysql.com/downloads/

The following example uses the Connector/ODBC 3.51 that we downloaded in an msi format.

MyODBC-3.51.11-2-win.msi

The next screen ask you to read the licence conditions.

Accept the conditions if you don't mind.

The next screen show the readme infos

The installation proceed and files are copied.

MySQL ODBC driver configuration

The Driver configuration can be done directly from LoriotPro or from the Microsoft Windows ODBC Data Source Administrator tool.

To access the ODBC Data Source Administrator tool, open the Control Panel, select Adminstrative Tools, the Data Source (ODBC).

The following screen is displayed:

If you have well installed the MySQL ODBC 3.51 driver you should see it in the driver tab.

DSN setting

A Data Source Name should be created to allow LoriotPro to access to the SQL DataBase

What is a DSN: (Short for Data Source Name). Data Source Name provides connectivity to a database through an ODBC driver. The DSN contains database name, directory, database driver, UserID, password, and other information. Once you create a DSN for a particular database, you can use the DSN in an application to call information from the database.

There are three types of DSNs:

System DSN -- can be used by anyone who has access to the machine. DSN info is stored in the registry.
User DSN -- created for a specific user. Also stored in the registry.
File DSN -- DSN info is stored in a text file with .DSN extension.

We choose to create a System DSN. We select the System DSN tab.

We cclick next on the Add button, a list of driver is displayed. We choose the MySQL ODBC driver.

MySQL ConnectorODBC settings

The Connector ODBC windows setup is displayed.

You should enter the following parameters:

Data Source Name	A name used to identify this DSN
Description	Description of this DSN
Server	the Server name or IP address where the Database Server is installed
User	The user name used to acces the Database
Password	The Password of this user
Database	The database name *(Must be 'loriotpro')*

When the field are set you can check the connection to the datanase.

Click on the Test button.

Now the new DSN is available in the DSN list

You can leave the ODBC Data Source Administrator tool.

www.loriotpro.com

Copyright © 2004 LUTEUS SARL. All rights reserved. This documentation is copyrighted by LUTEUS SARL. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying or otherwise, without the prior express written permission of LUTEUS SARL